Release 10.1A: OpenEdge Development:
Internationalizing Applications

SQLDUMP

SQLDUMP lets you dump SQL databases. The syntax (for UNIX and Windows) is:

Syntax

sqldump -u username -a password -t table-name[,table-name ...] database-url [-C charset] [-F { comma | quote }] [-f command-filename] [-n error-check]

username, password

User authentication.

table-name[,table-name ...]

One or more tables to dump. Multiple tables can be specified, in a comma-separated list. Specify a table of % to dump all tables. The -t option can be specified only if the -f option is not.

database-url

The database to which you want to connect. This has the following form:

progress:T:host-name:service-name:database-name

charset

The name of the character set of the tables to be dumped.

{ comma | quote }

If comma is specified, dump in comma-delimited format. If quote is specified, dump in quote-delimited format. The default is quote.

command-filename

Specifies the file where SQLDUMP reads commands on how and what to dump. The -f option can be specified only if the -t option is not.

error-check

Check for syntax errors without dumping any rows.